create procedure [dbo].[BAEEventSetupRemoveFunctionGroup] @functionCode varchar(16),
     @eventCode varchar(16),
     @groupName varchar(8) as
DECLARE @thisFunctionorder AS INT
    
    /* Get function order before delete */
    SELECT @thisFunctionorder = FunctionOrder
    FROM EventSetupFunctionGroup
    WHERE FunctionCode = @functionCode AND EventCode = @eventCode;

    /*Update Function order */
    Update EventSetupFunctionGroup
    SET FunctionOrder = FunctionOrder - 1
    WHERE EventCode = @eventCode AND GroupName = @groupName AND FunctionOrder > @thisFunctionorder;

    /* Delete Function */    
    DELETE FROM EventSetupFunctionGroup
    WHERE FunctionCode = @functionCode AND EventCode = @eventCode;

GO